package com.javaweb.admin.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.javaweb.admin.entity.NCPOOrder;
import com.javaweb.admin.entity.NCPOOrderDetail;
import com.javaweb.admin.entity.NCSOOrder;
import com.javaweb.admin.entity.NCSOOrderDetail;
import com.javaweb.admin.query.NCPOOrderQuery;
import com.javaweb.admin.query.NCSOOrderQuery;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface NCSOOrderMapper {
    IPage<NCSOOrder> getNCSOOrderList(IPage<NCSOOrder> page, @Param("req") NCSOOrderQuery req);

    @Select("select * from v_kdl_nc_so_order_detail where pk_order=#{pkOrder} order by invcode,vlotno,dprodate")
    List<NCSOOrderDetail> getNCSOOrderDetailList(String pkOrder);
}
